﻿CREATE PROC Inv.spObtenDiasEvento
	@pnIdInvitacion	INT
AS
BEGIN
	SET NOCOUNT OFF;
		
	SELECT	DATEDIFF(DAY, GETDATE(), FechaEvento) AS DiasEvento,
			CONVERT(VARCHAR(10), DATEDIFF(DAY, GETDATE(), FechaEvento)) + ' días' AS DiasEventoDesc
	FROM	Inv.Invitacion 
	WHERE	IdInvitacion	= @pnIdInvitacion
		
	SET NOCOUNT ON;
END